select distinct(billing_date) from billing_on_cheader1 where provider_no = '{provider_no}' and status != 'D' and billing_date >= '{billing_date_from}' and billing_date <= '{billing_date_to}' and pay_program='HCP' order by billing_date select provider_no, CONCAT(last_name, ', ', first_name, ' (', provider_no, ')') from provider order by last_name;